--Execute as oe/oe
CREATE TYPE typ_Project AS OBJECT(  --create object
   project_no NUMBER(4), 
   title      VARCHAR2(35),
   cost       NUMBER(12,2))
/
CREATE TYPE typ_ProjectList AS VARRAY (50) OF typ_Project
	  -- define VARRAY type
/
Drop table department
/
CREATE TABLE department (  -- create database table
   dept_id  NUMBER(2),
   name     VARCHAR2(25),
   budget   NUMBER(12,2),
   projects typ_ProjectList)  -- declare varray as column
/